# -*- coding:utf-8 -*-
"""
Author：Administrator
Date:2023年03月20日
"""
import  openpyxl

myBook = openpyxl.load_workbook('收入表.xlsx')
mySheet=myBook.active
myPatternFill=openpyxl.styles.PatternFill(fill_type='lightGrid',fgColor='00FFFF')
for myRow in mySheet['A5:D8']:
	for myCell in myRow:
		myCell.fill = myPatternFill
myBook.save('结果表-收入表.xlsx')